Create Language Alias Pipeline.
Introduction
This document is all about how to use Language Parameter functionalities. In this document, you will learn about how to crate Pipeline using Language Parameter. In Language Parameter you can add language as per your requirements.
Prerequisites
To create a Pipeline, you need working Datasets(JDBC) and a list of tables and views.
Objective
How to use Language Parameter in Pipeline.
Download Pipeline.zip file from the link given Pipeline.zip
Follow steps to create Language Parameter Pipeline in OPNBI:-
From this document, you will learn how to create the Pipeline, which contains user-required Language parameters.
Login to the OPNBI application with valid user credentials.
Go to Master Data > Dataset section from the hamburger menu.
Go to the Dataset section, Click on Create Pipeline from the bottom menu bar. As shown in the figure below:
Once you click, you can see a blank create pipeline window as in the below image:
Enter the Following detail in the Pipeline dialog box:
Name: Language Alias
Source: OPNBI-mapping
Expand tables from the left side table view, As shown in the figure below:
Drag and Drop the CUSTOMER table from the table list box to the diagram box, as shown in the figure below:
Select all columns and click on Submit button as shown in the figure below:
Select and drag and drop the Office table from the table list, To add Alias in Table, click on Add Language Column button, as shown in the figure below:
When you click on the Language Column button Enter Language pop-up will be displayed, Enter the name of custom Alias as Hindi, Click on Add Language button, as shown in the following figure.
After adding the Language Column, it is visible in the Customer dialog box, as Alias_Hindi, as shown in the figure below
Add Custom Name of the column you want to add a language Add the Custom name of the Alias Category Language, here we are given names in Hindi by state and country as shown in the figure below:
Select all the columns of the Office table, click on the Save button, as shown in the figure below:
Drag the country column from CUSTOMER to OFFICE table field, as shown in the figure below:
Enable the Add Language Parameter by clicking the following Checkbox as shown in the figure.
Click on Submit to save the pipeline.
The pipeline is run in the Adhoc Analysis.
Go to Documents > Adhoc Analysis section from Hamburger menu.
In Adhoc Analysis click on the + icon to create a new Analysis, as shown in the figure below:
When you click on create Analysis then the Analysis Selection dialog box will open, as shown in the figure below:
Enter the following details in Analysis Section:
Dataset: Language Alias (select the Pipeline, which you are created)
When you select the dataset(Pipeline) it will show Dataset Parameter Pop-up, as shown in the figure below:
In Lang write Hindi, as shown in the figure below:
Click on submit.
The two tables will get load the left side box of Pipeline view, Now expends the OFFICES table.
Drag and drop STATE column from OFFICES to Rows, Drag and drop a COUNTRY column from OFFICE and Put it in Column box, Drag and drop the CREDIT LIMIT column from Customers to Values box (Select sum in Type), as shown in the figure below:
Click on Preview Button it will show the output and after the preview click on Cancel Button it will show the screen as follows:
Click on Save as
icon for saving the Analysis, it will show the screen as below:
Give the name of Analysis.
Name: Lang Parameter Pipeline and Select the folder where you want to save Analysis, as shown in the figure below:
Click on Save As button to save Analysis.